package com.czxy.dao;

import com.czxy.pojo.SkuComment;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

/**
 * sku评论
 * @author Liuyunqin 17674029449@163.com
 * @date 2018/12/25 9:55
 */
@org.apache.ibatis.annotations.Mapper
public interface SkuCommentMapper extends Mapper<SkuComment> {

    /**
     * 根据skuID查询 此sku商品的 **评价数量
     * @param skuId
     * @return
     */
    @Select("SELECT COUNT(*) FROM tb_sku_comment WHERE sku_id=#{skuId}")
    public Integer findCountBySkuId(@Param("skuId") Integer skuId);
}
